Release 10.1A: OpenEdge Data Management:
SQL Reference

Character-string literals

A character-string literal is a string of characters enclosed in single quotation marks ( ' '). To include a single quotation mark in a character-string literal, precede it with an additional single quotation mark.

Example

The INSERT statements in the following example show embedding quotation marks in character-string literals:

insert into quote values('unquoted literal'); insert into quote values('''single-quoted literal'''); insert into quote values('"double-quoted literal"'); insert into quote values('O''Hare');select * from quote; c1 -- unquoted literal 'single-quoted literal' "double-quoted literal" O’Hare 4 records selected

Note: A character string literal can contain multi-byte characters in the character set used by the SQL client. Only single-byte ASCII-encoded quote marks are valid in the syntax.